Vba support

€8-30 EUR

완료함

게시됨

거의 3년 전

€8-30 EUR

제출할때 지불됩니다

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: 30281426

프로젝트 정보

19 제안서

원격근무 프로젝트

활동 중 3년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

프로젝트를 수여된 사용자:

@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 1일에

0.0

(0 건의 리뷰)

0.0

19 이 프로젝트에 프리랜서들의 평균 입찰은 €27 EUR입니다.

@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 1일에

5.0

(300 건의 리뷰)

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 1일에

4.9

(27 건의 리뷰)

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 7일에

4.9

(5 건의 리뷰)

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 1일에

4.9

(2 건의 리뷰)

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 1일에

5.0

(5 건의 리뷰)

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 7일에

5.0

(2 건의 리뷰)

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 1일에

4.6

(2 건의 리뷰)

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 2일에

5.0

(1 건의 리뷰)

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 7일에

0.0

(0 건의 리뷰)

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 1일에

5.0

(1 건의 리뷰)

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 7일에

0.0

(0 건의 리뷰)

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 2일에

0.0

(0 건의 리뷰)

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 1일에

0.0

(0 건의 리뷰)

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 7일에