Vba support

€8-30 EUR

Opravljeno

Objavljeno

pred skoraj 3 leti

€8-30 EUR

Plačilo ob dostavi

Hello, I'm usign a Vba script in order to get data from SQL server, and used locally it working but when I'm using remote link doesn't'. This is the scrip Sub getDataComplessivoMagPg() Dim sConnString As String Set conn = CreateObject("[login to view URL]") Set rs = CreateObject("[login to view URL]") Server_Name = "2.122.427.112:14330" Database_Name = "mydb" User_ID = "admin" Password = "admin 1243" ' Create the connection string. sConnString = "Provider=SQLOLEDB;Data Source=" & Server_Name & ";Network Library=DBMSSOCN;Initial Catalog=" & Database_Name & ";User Id=" & User_ID & ";Password=" & Password & "" ' Open the connection and execute. [login to view URL] sConnString SQLStr = "SELECT * FROM customer_table" Set rs = [login to view URL](SQLStr) ' Set formula calculation Manual [login to view URL] = xlManual ' Check we have data. If Not [login to view URL] Then Sheets("ArcaMag").Range("O1:T10000") = "" ' Transfer result. Sheets("ArcaMag").Range("O1").CopyFromRecordset rs ' Close the recordset [login to view URL] Else MsgBox "Error: No records returned.", vbCritical End If ' Clean up If CBool([login to view URL] And adStateOpen) Then [login to view URL] Set conn = Nothing Set rs = Nothing 'MsgBox "Done!", vbInformation, "Done!" End Sub

Visual Basic

Excel

Microsoft SQL Server

ID projekta: 30281426

Več o projektu

19 ponudb

Projekt na daljavo

Aktivno pred 3 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@tandat010280

Dear, If you can connect locally, I do not think this issue is from your code, please troubleshoot something on SQL server as [login to view URL]:~:text=Connect%20to%20your%20server%20and,is%20checked%20and%20click%20OK. Cheers, Dat Tan

€8 EUR v 1 dnevu

0,0

(0 ocen)

0,0

19 freelancerjev je oddalo ponudbo s povprečno vrednostjo €27 EUR za to delo

@sumon355

Hello, As an expert in ms sql server and having sound knowledge in working with VBA, I am very much interested to fix the issue you are having in connecting remote sql server. Looking forward to have a positive response from you. Thanks

€30 EUR v 1 dnevu

5,0

(300 ocen)

7,8

@tutulsoft

Hi, it is not issue with your Script , VBA script is okay ... need some configuration at your windows , then you can connect remote sql server with this vba script

€30 EUR v 1 dnevu

4,9

(27 ocen)

5,5

@fchorley99

Hello, I see so much nonsense for 20 seconds of effort. Che palle. Use a comma, not a colon for the port. That was 10 seconds.

€10 EUR v 7 dneh

4,9

(5 ocen)

4,3

@Ahzakaria

I’m working on the same sql database structure and I faced this issue many time for the clients and I need to know the error message

€10 EUR v 1 dnevu

4,9

(2 ocen)

2,6

@arunodaya123

HI, Hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects, I has done tons of projects on AQL ADODB connections using VBA. I can solve your issue. I can give my full effort to deliver this project in on time with 100% quality and accuracy. I am waiting for your kind response.

€20 EUR v 1 dnevu

5,0

(5 ocen)

2,5

@bizmanas

HI I have 15 years experience in Microsoft SQL Server Database Development, Postgres Development, MYSQL Database Development, C#, Python and PowerBI I would be able to help you with the project. Please ping me offline to discuss further

€80 EUR v 7 dneh

5,0

(2 ocen)

1,5

@RenMhy

I have sufficient experience working with VB6 and since it is what VBA is using then I think I can help you on this. Besides you said it is working locally yet.

€8 EUR v 1 dnevu

4,6

(2 ocen)

0,9

@niarfedevelop

Hello, best regards, currently I have more than 15 years of experience working with VB connecting it with any database management system (SQL SERVER, MYSQL, MARIADB, POSTGRESQL, ACCESS).

€25 EUR v 2 dneh

5,0

(1 ocena)

1,0

@Ayush2425

I have a great experience in this field and i am hard working and my certificate issued by the govt. of India . I am interested in these project. If you hire me, you will get many services at one time investment. I am very much confident of our succession together as I am punctual and creative. I look forward to hear from you soon. Thank you.

€19 EUR v 7 dneh

0,0

(0 ocen)

0,0

@Irtazarao49

hey i can help you to connect your db i read your code i can also look for the problem and sort it out . im full stack developer so please hand over me the task so we will sort it out !

€29 EUR v 1 dnevu

5,0

(1 ocena)

0,0

@rohitnayakn2

I have been working with this skills for less thena year and are skills learning. I am beginner in this skills.I will do you a good job in the shortest possible time.

€20 EUR v 7 dneh

0,0

(0 ocen)

0,0

@torsaab994

Hi How are you?. I hope you are fine. My name Satpal Singh. I read your project detail your coding is right but this is not work when you use it. I can slove your problem. I have knowledge of VBA. So discuss about this project in chat with me.

€17 EUR v 2 dneh

0,0

(0 ocen)

0,0

@daveroberts007

Hello there, I think I can see what is wrong with your script. Please accept my proposal and I will explain to you what you need to change. If what I think is wrong with it we can work together to establish the problem. I have years of experience supporting SQL installations and the various software clients that connect to them.

€20 EUR v 1 dnevu

0,0

(0 ocen)

0,0

@ajmalganii

I have been working in MS SQL for 6 years, Please let me know your requirements I can help you. I have been working in VBA for 6 years, Please let me know your requirements I can help you.

€25 EUR v 7 dneh