Vba support

€8-30 EUR

Completed

Posted

almost 3 years ago

€8-30 EUR

Paid on delivery

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

Project ID: 30281426

About the project

19 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 1 day

0.0

(0 reviews)

0.0

19 freelancers are bidding on average €27 EUR for this job

@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 in 1 day

5.0

(300 reviews)

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 in 1 day

4.9

(27 reviews)

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 in 7 days

4.9

(5 reviews)

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 in 1 day

4.9

(2 reviews)

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 in 1 day

5.0

(5 reviews)

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 in 7 days

5.0

(2 reviews)

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 in 1 day

4.6

(2 reviews)

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 in 2 days

5.0

(1 review)

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 in 7 days

0.0

(0 reviews)

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 in 1 day

5.0

(1 review)

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 in 7 days

0.0

(0 reviews)

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 in 2 days

0.0

(0 reviews)

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 in 1 day

0.0

(0 reviews)

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 in 7 days