Vba support

€8-30 EUR

Fullført

Lagt ut

nesten 3 år siden

€8-30 EUR

Betalt ved levering

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

Prosjekt-ID: 30281426

Om prosjektet

19 forslag

Eksternt prosjekt

Aktiv 3 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@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 om 1 dag

0,0

(0 omtaler)

0,0

19 frilansere byr i gjennomsnitt €27 EUR for denne jobben

@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 om 1 dag

5,0

(300 omtaler)

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 om 1 dag

4,9

(27 omtaler)

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 om 7 dager

4,9

(5 omtaler)

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 om 1 dag

4,9

(2 omtaler)

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 om 1 dag

5,0

(5 omtaler)

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 om 7 dager

5,0

(2 omtaler)

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 om 1 dag

4,6

(2 omtaler)

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 om 2 dager

5,0

(1 omtale)

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 om 7 dager

0,0

(0 omtaler)

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 om 1 dag

5,0

(1 omtale)

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 om 7 dager

0,0

(0 omtaler)

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 om 2 dager

0,0

(0 omtaler)

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 om 1 dag

0,0

(0 omtaler)

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 om 7 dager